<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateVipPackageTable extends Migration
{
    /**
     * (非)会员套餐表
     *
     * @return void
     */
    public function up(){
        Schema::create('vip_package', function (Blueprint $table) {
            $table->engine='MyISAM';
            $table->comment='(非)会员套餐表';
            $table->increments('id')->unsigned()->comment('自增长主键');
            $table->string('vipname',60)->unique('vipname')->default('')->comment('会员名称');
            $table->mediumInteger('vip_days')->unsigned()->default(0)->comment('会员天数');
            $table->mediumInteger('vip_resume_number')->unsigned()->default(0)->comment('会员简历数');
            $table->mediumInteger('vip_integral')->unsigned()->default(0)->comment('会员积分');
            $table->mediumInteger('vip_post_number')->unsigned()->default(0)->comment('会员职位数');
            $table->mediumInteger('resume_number')->unsigned()->default(0)->comment('非会员简历数');
            $table->mediumInteger('integral')->unsigned()->default(0)->comment('非会员积分');
            $table->tinyInteger('stats')->unsigned()->default(0)->comment('0显示，1前台不显示');
            $table->decimal('money',8,2)->default('0.00')->comment('会员价格');
            $table->timestamps();
        });
    }
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down(){
        Schema::drop('vip_package');
    }
}
